Merge Data Table

AutomatR.DefaultActivities.Datatable.MergeDataTable

The "Merge Data Table" activity in AutomatR allows you to merge the destination DataTable with the source DataTable. This activity is useful for combining data from two DataTables into a single DataTable.

Properties

Name	Description
Input
Data Table 1	Specifies the first DataTable required to perform the merge operation. Variable or argument containing the first DataTable.
Data Table 2	Specifies the second DataTable required to perform the merge operation. Variable or argument containing the second DataTable.
Misc
Display Name	Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variable or argument containing the desired display name.
Optional
Delay	Specifies the amount of time (in seconds) to wait before executing the "Merge Data Table" activity. This can be useful for handling synchronization issues. Integer variable or argument containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1.
Output
Result	Outputs the DataTable based on the merge operation between the specified DataTables. Variable or argument to store the resulting DataTable.

How to use:

1. Drag and drop the "Merge Data Table" activity onto the workflow.
2. Configure the properties by specifying the first DataTable and second DataTable for the merge operation.
3. Optionally, configure the delay and customize the display name.
4. Execute the workflow to perform the merge operation, and the resulting DataTable will be stored in the specified variable.

Example: Consider an example where the "Merge Data Table" activity is used to combine data from two DataTables:

Merge Data Table:
  Display Name: "MergeDataTableActivity"
  Data Table 1: dataTable1Variable
  Data Table 2: dataTable2Variable
  Result: mergedDataTableVariable

In this example, the activity merges the data from "dataTable1Variable" and "dataTable2Variable" into a new DataTable, and the result is stored in the variable "mergedDataTableVariable."